package com.example.icedcap.topeka_fake.persistance;

import android.provider.BaseColumns;

/**
 * Created by doushuqi on 15-7-13下午10:20.
 * Email:doushuqi0409@gmail.com
 *
 * Structure of the category table.
 */
public interface CategoryTable {
    String NAME = "category";

    String COLUMN_ID = BaseColumns._ID;
    String COLUMN_NAME = "name";
    String COLUMN_THEME = "theme";
    String COLUMN_SCORES = "scores";
    String COLUMN_SOLVED = "solved";

    String[] PROJECTION = new String[] {
            COLUMN_ID,
            COLUMN_NAME,
            COLUMN_THEME,
            COLUMN_SCORES,
            COLUMN_SOLVED
    };

    String CREATE = "CREATE TABLE " + NAME + " ("
            + COLUMN_ID + " TEXT PRIMARY KEY, "
            + COLUMN_NAME + " TEXT NOT NULL, "
            + COLUMN_THEME + " TEXT NOT NULL, "
            + COLUMN_SCORES + " TEXT NOT NULL, "
            + COLUMN_SOLVED + " TEXT NOT NULL);";
}
